package com.ckf.login_wx.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ckf.login_wx.entity.Material;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface MaterialMapper extends BaseMapper<Material> {

	@Select("select * from material where time like concat('%',#{talk},'%')")
	public List<Material> seletime(String talk);
	@Select("select * from material where time like concat('%',#{name},'%') and saisie =#{saisie}")
	public List<Material> seletimebyquan(@Param("name") String name,@Param("saisie") String saisie);
	@Select("select * from material where ${likename} like concat('%',#{name},'%')")
	public List<Material> selectlike(@Param("likename") String likename,@Param("name") String name);
}
